package jpa.entitys.synchro.staging;

import java.io.Serializable;
import java.math.BigDecimal;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the MM_POCONTRACTOR_OUTB database table.
 * 
 */
@Entity
@Table(name="MM_POCONTRACTOR_OUTB")
@NamedQueries({
    @NamedQuery(name = "MmPocontractorOutb.findAll", query = " SELECT c FROM MmPocontractorOutb c "),
    @NamedQuery(name = "MmPocontractorOutb.findById", query = " SELECT c FROM MmPocontractorOutb c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "MmPocontractorOutb.findByInstanceNo", query = " SELECT c FROM MmPocontractorOutb c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.promisStagingId asc"),
    @NamedQuery(name = "MmPocontractorOutb.findByDocumentNo", query = " SELECT c FROM MmPocontractorOutb c WHERE c.company = :company And c.project = :project And c.documentNo = :documentNo And c.subStatus = :subStatus And c.issync = :issync order by c.instanceNo, c.subStatus asc"),
    @NamedQuery(name = "MmPocontractorOutb.findByContractType", query = " SELECT c FROM MmPocontractorOutb c WHERE c.contractType = :contractType And c.subStatus = :subStatus order by c.instanceNo asc"),
    @NamedQuery(name = "MmPocontractorOutb.findAllIsSync", query = " SELECT c FROM MmPocontractorOutb c WHERE c.issync = :issync order by c.instanceNo asc")
    })
public class MmPocontractorOutb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;

	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandler;

	@Column(length=2)
	private String company;
	
	@Column(name="PROJECT")
	private String project;

	@Column(name="CONTRACT_DATE", length=8)
	private String contractDate;

	@Column(name="CONTRACT_GUARANTEE_AMOUNT", length=30)
	private String contractGuaranteeAmount;

	@Column(name="CONTRACT_GUARANTEE_PERCENT", length=30)
	private String contractGuaranteePercent;

	@Column(name="CONTRACT_NO", length=100)
	private String contractNo;

	@Column(name="CONTRACT_TYPE", length=10)
	private String contractType;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(name="CURRENCY_CODE", length=5)
	private String currencyCode;

	@Column(length=30)
	private String description;

	@Column(name="DOCUMENT_NO", length=100)
	private String documentNo;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(name="INSTALLMENT_AMOUNT", length=30)
	private String installmentAmount;

	@Column(name="INSTALLMENT_DUE_DATE", length=10)
	private String installmentDueDate;

	@Column(name="INSTALLMENT_NUMBER")
	private BigDecimal installmentNumber;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(name="MODEL_CODE", length=30)
	private String modelCode;

	@Column(name="MODEL_DESC", length=300)
	private String modelDesc;

	@Column(name="MODEL_REVISION", length=3)
	private String modelRevision;

	@Column(name="MSG_ACT_RESULT", length=3700)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=3700)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=1500)
	private String msgCode;

	@Column(name="MSG_DESC", length=3700)
	private String msgDesc;

	@Column(name="PN_PERDAY", length=30)
	private String pnPerday;

	@Column(name="RETENTION_AMOUNT", length=30)
	private String retentionAmount;

	@Column(name="RETENTION_PERCENT", length=30)
	private String retentionPercent;

	@Column(name="SAP_ACC_ASS", length=1)
	private String sapAccAss;

	@Column(name="SAP_COMPANY_CODE", length=4)
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE", length=4)
	private String sapPlantCode;

	@Column(name="SAP_PURCH_DOC_TYPE", length=4)
	private String sapPurchDocType;

	@Column(name="SAP_PURCH_GROUP", length=4)
	private String sapPurchGroup;

	@Column(name="SAP_PURCH_ORG", length=4)
	private String sapPurchOrg;

	@Column(name="SUB_STATUS", length=2)
	private String subStatus;

	@Column(name="SUPPLIER_CODE", length=30)
	private String supplierCode;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_CODE", length=2)
	private String taxCode;

	@Column(name="UNIT_NUMBER", length=30)
	private String unitNumber;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;
	
	@Column(name="PO_CONTRACT_TYPE", length=100)
	private String poContractType;

	@Column(name="STATUS")
	private String status;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;	
	
	@Column(name="REF_SYNC_PK_ID", length=100)
	private String refSyncPkId;
	
	@Column(name="RMS_IS_PAID", length=100)
	private String rmsIsPaid;
	
	@Column(name="ACTIVITY_GROUP_CODE", length=100)
	private String activityGroupCode;
	
	@Column(name="ACTIVITY_GROUP_DESC", length=100)
	private String activityGroupDesc;
	
	@Column(name="PROPERTY_CATEGORY", length=100)
	private String propertyCategory;
	
	@Column(name="START_DATE", length=100)
	private String startDate;
	
	@Column(name="END_DATE", length=100)
	private String endDate;
	
	@Column(name="ITEM_STATUS")
	private String itemStatus;	
	
	@Column(name="CONT_UNIT_SEQ")
	private String contUnitSeq;	
	
	@Column(name="INSTALLMENT_NUMBER_STR")
	private String installmentNumberStr;
	
    /**
	 * @return the installmentNumberStr
	 */
	public String getInstallmentNumberStr() {
		return installmentNumberStr;
	}

	/**
	 * @param installmentNumberStr the installmentNumberStr to set
	 */
	public void setInstallmentNumberStr(String installmentNumberStr) {
		this.installmentNumberStr = installmentNumberStr;
	}

	/**
	 * @return the contUnitSeq
	 */
	public String getContUnitSeq() {
		return contUnitSeq;
	}

	/**
	 * @param contUnitSeq the contUnitSeq to set
	 */
	public void setContUnitSeq(String contUnitSeq) {
		this.contUnitSeq = contUnitSeq;
	}

	/**
	 * @return the itemStatus
	 */
	public String getItemStatus() {
		return itemStatus;
	}

	/**
	 * @param itemStatus the itemStatus to set
	 */
	public void setItemStatus(String itemStatus) {
		this.itemStatus = itemStatus;
	}

	/**
	 * @return the startDate
	 */
	public String getStartDate() {
		return startDate;
	}

	/**
	 * @param startDate the startDate to set
	 */
	public void setStartDate(String startDate) {
		this.startDate = startDate;
	}

	/**
	 * @return the endDate
	 */
	public String getEndDate() {
		return endDate;
	}

	/**
	 * @param endDate the endDate to set
	 */
	public void setEndDate(String endDate) {
		this.endDate = endDate;
	}

	/**
	 * @return the propertyCategory
	 */
	public String getPropertyCategory() {
		return propertyCategory;
	}

	/**
	 * @param propertyCategory the propertyCategory to set
	 */
	public void setPropertyCategory(String propertyCategory) {
		this.propertyCategory = propertyCategory;
	}

	/**
	 * @return the activityGroupDesc
	 */
	public String getActivityGroupDesc() {
		return activityGroupDesc;
	}

	/**
	 * @param activityGroupDesc the activityGroupDesc to set
	 */
	public void setActivityGroupDesc(String activityGroupDesc) {
		this.activityGroupDesc = activityGroupDesc;
	}

	/**
	 * @return the activityGroupCode
	 */
	public String getActivityGroupCode() {
		return activityGroupCode;
	}

	/**
	 * @param activityGroupCode the activityGroupCode to set
	 */
	public void setActivityGroupCode(String activityGroupCode) {
		this.activityGroupCode = activityGroupCode;
	}

	/**
	 * @return the rmsIsPaid
	 */
	public String getRmsIsPaid() {
		return rmsIsPaid;
	}

	/**
	 * @param rmsIsPaid the rmsIsPaid to set
	 */
	public void setRmsIsPaid(String rmsIsPaid) {
		this.rmsIsPaid = rmsIsPaid;
	}

	/**
	 * @return the refSyncPkId
	 */
	public String getRefSyncPkId() {
		return refSyncPkId;
	}

	/**
	 * @param refSyncPkId the refSyncPkId to set
	 */
	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

    /**
	 * @return the poContractType
	 */
	public String getPoContractType() {
		return poContractType;
	}

	/**
	 * @param poContractType the poContractType to set
	 */
	public void setPoContractType(String poContractType) {
		this.poContractType = poContractType;
	}

	/**
	 * @return the project
	 */
	public String getProject() {
		return project;
	}

	/**
	 * @param project the project to set
	 */
	public void setProject(String project) {
		this.project = project;
	}

	public MmPocontractorOutb() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
		super.setPromisStagingId(promisStagingId);
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getContractDate() {
		return this.contractDate;
	}

	public void setContractDate(String contractDate) {
		this.contractDate = contractDate;
	}

	public String getContractGuaranteeAmount() {
		return this.contractGuaranteeAmount;
	}

	public void setContractGuaranteeAmount(String contractGuaranteeAmount) {
		this.contractGuaranteeAmount = contractGuaranteeAmount;
	}

	public String getContractGuaranteePercent() {
		return this.contractGuaranteePercent;
	}

	public void setContractGuaranteePercent(String contractGuaranteePercent) {
		this.contractGuaranteePercent = contractGuaranteePercent;
	}

	public String getContractNo() {
		return this.contractNo;
	}

	public void setContractNo(String contractNo) {
		this.contractNo = contractNo;
	}

	public String getContractType() {
		return this.contractType;
	}

	public void setContractType(String contractType) {
		this.contractType = contractType;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrencyCode() {
		return this.currencyCode;
	}

	public void setCurrencyCode(String currencyCode) {
		this.currencyCode = currencyCode;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getDocumentNo() {
		return this.documentNo;
	}

	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstallmentAmount() {
		return this.installmentAmount;
	}

	public void setInstallmentAmount(String installmentAmount) {
		this.installmentAmount = installmentAmount;
	}

	public String getInstallmentDueDate() {
		return this.installmentDueDate;
	}

	public void setInstallmentDueDate(String installmentDueDate) {
		this.installmentDueDate = installmentDueDate;
	}

	public BigDecimal getInstallmentNumber() {
		return this.installmentNumber;
	}

	public void setInstallmentNumber(BigDecimal installmentNumber) {
		this.installmentNumber = installmentNumber;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
		super.setInstanceNo(instanceNo);
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getModelCode() {
		return this.modelCode;
	}

	public void setModelCode(String modelCode) {
		this.modelCode = modelCode;
	}

	public String getModelDesc() {
		return this.modelDesc;
	}

	public void setModelDesc(String modelDesc) {
		this.modelDesc = modelDesc;
	}

	public String getModelRevision() {
		return this.modelRevision;
	}

	public void setModelRevision(String modelRevision) {
		this.modelRevision = modelRevision;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPnPerday() {
		return this.pnPerday;
	}

	public void setPnPerday(String pnPerday) {
		this.pnPerday = pnPerday;
	}

	public String getRetentionAmount() {
		return this.retentionAmount;
	}

	public void setRetentionAmount(String retentionAmount) {
		this.retentionAmount = retentionAmount;
	}

	public String getRetentionPercent() {
		return this.retentionPercent;
	}

	public void setRetentionPercent(String retentionPercent) {
		this.retentionPercent = retentionPercent;
	}

	public String getSapAccAss() {
		return this.sapAccAss;
	}

	public void setSapAccAss(String sapAccAss) {
		this.sapAccAss = sapAccAss;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getSapPurchDocType() {
		return this.sapPurchDocType;
	}

	public void setSapPurchDocType(String sapPurchDocType) {
		this.sapPurchDocType = sapPurchDocType;
	}

	public String getSapPurchGroup() {
		return this.sapPurchGroup;
	}

	public void setSapPurchGroup(String sapPurchGroup) {
		this.sapPurchGroup = sapPurchGroup;
	}

	public String getSapPurchOrg() {
		return this.sapPurchOrg;
	}

	public void setSapPurchOrg(String sapPurchOrg) {
		this.sapPurchOrg = sapPurchOrg;
	}

	public String getSubStatus() {
		return this.subStatus;
	}

	public void setSubStatus(String subStatus) {
		this.subStatus = subStatus;
	}

	public String getSupplierCode() {
		return this.supplierCode;
	}

	public void setSupplierCode(String supplierCode) {
		this.supplierCode = supplierCode;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxCode() {
		return this.taxCode;
	}

	public void setTaxCode(String taxCode) {
		this.taxCode = taxCode;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}